My SQL in a Main Memory Database Context
نویسندگان
چکیده
In main memory database systems (MMDB) the primary copy of data is stored in memory. This paper explores how main memory residency of data impacts data management, and examines MySQL 4.1 in this context. Suggestions on how to improve the main memory parts of MySQL are presented.
منابع مشابه
Multi-versioning in Main-memory Databases: Limitations and Opportunities
Multi-version database systems preserve the explicit history of values taken by each database record. They do so by maintaining versions; if the value of a record needs to be updated, the system creates a new version, while keeping the previous value untouched. In contrast, a single-version database system updates records in place. As a consequence, in his seminal paper describing the “transact...
متن کاملMain Memory Databases vs. Disk-Resident Databases
Storing all database data in memory is an idea that many researchers have been studying it from mid-1980s when RAM prices decreased while their capacity increased. Main Memory Database systems (MMDB) are an efficient solution to store all database data in main physical memory. Conventional database systems like relational databases are optimized for disk I/O operations but Memory resident datab...
متن کاملClassifying ELH Ontologies In SQL Databases
The current implementations of ontology classification procedures use the main memory of the computer for loading and processing ontologies, which soon can become one of the main limiting factors for very large ontologies. We describe a secondary memory implementation of a classification procedure for ELH ontologies using an SQL relational database management system. Although secondary memory h...
متن کاملIntegrating Pattern Growth Mining on SQL-Server RDBMS
Most of the FIMI implementations are memory-like. However when we deal with data warehouse the size of datasets are extremely huge for memory copy. However, using a pure SQL-like approach is inefficient, even almost implementations rarely take advantages of SQL-Extensions such as SQL-Cursors, Store Procedures and UDF functions. Furthermore, RDBMS vendors offer a lot of SQL-Extensions for taking...
متن کاملInteractive Relation Extraction in Main Memory Database Systems
We present INDREX-MM, a main memory database system for interactively executing two interwoven tasks, declarative relation extraction from text and their exploitation with SQL. INDREXMM simplifies these tasks for the user with powerful SQL extensions for gathering statistical semantics, for executing open information extraction and for integrating relation candidates with domain specific data. ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2004